<?php
pdo_query("CREATE TABLE IF NOT EXISTS `ims_slj123_pc_content` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`from_place` varchar(255) NOT NULL,
`to_place` varchar(255) NOT NULL,
`user_id` int(11) NOT NULL,
`type` int(11) NOT NULL COMMENT '类型 1:人找车 2:车找人',
`start_time` int(11) NOT NULL,
`mid_place` varchar(255) NOT NULL,
`car` varchar(255) NOT NULL,
`user_count` varchar(255) NOT NULL,
`note` varchar(255) NOT NULL,
`top_time` int(11) NOT NULL,
`postdate` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`phone` varchar(255) NOT NULL,
`sex` int(11) NOT NULL,
`head` varchar(255) NOT NULL,
`istop` tinyint(2) NOT NULL DEFAULT '0' COMMENT '0为不置顶，1为置顶',
`order_id` int(11) NOT NULL,
`status` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_slj123_pc_index` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`from_place` varchar(255) NOT NULL,
`mid_place` varchar(255) NOT NULL,
`to_place` varchar(255) NOT NULL,
`user_id` int(11) NOT NULL DEFAULT '0',
`type` int(11) NOT NULL DEFAULT '0' COMMENT '类型 1:人找车 2:车找人',
`postdate` timestamp NOT NULL DEFAULT 0000-00-00 00:00:00 ,
`top_time` timestamp NULL DEFAULT 0000-00-00 00:00:00 ,
`start_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`valid_thru` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
`car` varchar(255) NOT NULL,
`user_count` varchar(255) NOT NULL,
`cost` decimal(12,2) unsigned NOT NULL DEFAULT '0.00',
`note` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`phone` varchar(255) NOT NULL,
`sex` int(11) NOT NULL DEFAULT '1',
`head` varchar(255) NOT NULL,
`status` int(11) NOT NULL DEFAULT '0',
`order_id` int(11) NOT NULL DEFAULT '0',
`from_longitude` decimal(18,10) NOT NULL DEFAULT '0.0000000000',
`from_latitude` decimal(18,10) NOT NULL DEFAULT '0.0000000000',
`to_latitude` decimal(18,10) NOT NULL DEFAULT '0.0000000000',
`to_longitude` decimal(18,10) NOT NULL DEFAULT '0.0000000000',
`view_count` int(10) unsigned NOT NULL DEFAULT '0',
`verified` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_slj123_pc_order` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`title` varchar(255) DEFAULT NULL,
`money` decimal(11,2) DEFAULT NULL,
`status` int(11) DEFAULT NULL COMMENT '0 未支付 1已支付',
`user_id` int(11) DEFAULT NULL,
`extra` varchar(255) DEFAULT NULL,
`create_time` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_slj123_pc_setting` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`people_post_cost` decimal(11,2) DEFAULT NULL DEFAULT '0.00' COMMENT '发布找人时金额',
`car_post_cost` decimal(11,2) DEFAULT NULL DEFAULT '0.00' COMMENT '发布找车时金额',
`car_post_cost1` decimal(11,2) DEFAULT NULL DEFAULT '0.00',
`car_post_cost2` decimal(11,2) DEFAULT NULL DEFAULT '0.00',
`top_time_cost` decimal(11,2) DEFAULT NULL DEFAULT '0.00' COMMENT '置顶每小时金额',
`banner` varchar(255) DEFAULT NULL COMMENT '首页广告位',
`notice_content` text DEFAULT NULL COMMENT '公告内容',
`notice_title` varchar(255) DEFAULT NULL COMMENT '公告标题',
`share_pic` varchar(255) DEFAULT NULL COMMENT '分享图片',
`share_title` varchar(255) DEFAULT NULL COMMENT '分享标题',
`share_des` varchar(255) NOT NULL,
`banner_link` text NOT NULL,
`notice` text NOT NULL,
`isopen_renzheng` int(10) NOT NULL,
`unitid` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_slj123_pc_sms_code` (
`openid` varchar(50) NOT NULL,
`code` varchar(10) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ,
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ims_slj123_pc_user` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`uid` int(10) NOT NULL,
`wx_open_id` varchar(255) DEFAULT NULL,
`wx_id` varchar(64) NOT NULL,
`nickname` varchar(64) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`tel` varchar(20) NOT NULL,
`sex` varchar(255) DEFAULT NULL,
`address` varchar(10) NOT NULL,
`head` varchar(255) DEFAULT NULL,
`mag_open_id` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`gender` tinyint(1) unsigned NOT NULL DEFAULT '0',
`identity` varchar(20) NOT NULL,
`realname` varchar(10) NOT NULL,
`area` varchar(30) NOT NULL,
`initial_driving_license_date` date NOT NULL DEFAULT '1970-01-01',
`car_number` varchar(10) NOT NULL,
`car_model` varchar(10) NOT NULL,
`car_color` varchar(10) NOT NULL,
`car_owner` varchar(10) NOT NULL,
`car_register_date` date NOT NULL DEFAULT '1970-01-01',
`driving_license` varchar(255) NOT NULL,
`driving_permit` varchar(255) NOT NULL,
`identity_front` varchar(255) NOT NULL,
`identity_back` varchar(255) NOT NULL,
`verified` tinyint(1) unsigned NOT NULL DEFAULT '0',
`update_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `ims_slj123_pc_user_uid` (`uid`),
UNIQUE KEY `ims_slj123_pc_user_openid` (`wx_open_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

");
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'id')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
	}	
}
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'weid')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `weid` int(10) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'from_place')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `from_place` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'to_place')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `to_place` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'user_id')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `user_id` int(11) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'type')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `type` int(11) NOT NULL COMMENT '类型 1:人找车 2:车找人';");
	}	
}
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'start_time')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `start_time` int(11) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'mid_place')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `mid_place` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'car')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `car` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'user_count')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `user_count` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'note')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `note` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'top_time')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `top_time` int(11) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'postdate')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `postdate` int(11) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'name')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `name` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'phone')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `phone` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'sex')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `sex` int(11) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'head')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `head` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'istop')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `istop` tinyint(2) NOT NULL DEFAULT '0' COMMENT '0为不置顶，1为置顶';");
	}	
}
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'order_id')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `order_id` int(11) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_content')) {
	if(!pdo_fieldexists('slj123_pc_content',  'status')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_content')." ADD `status` int(11) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'id')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'weid')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `weid` int(10) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'from_place')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `from_place` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'mid_place')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `mid_place` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'to_place')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `to_place` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'user_id')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `user_id` int(11) NOT NULL DEFAULT '0';");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'type')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `type` int(11) NOT NULL DEFAULT '0' COMMENT '类型 1:人找车 2:车找人';");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'postdate')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `postdate` timestamp NOT NULL DEFAULT 0000-00-00 00:00:00 ;");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'top_time')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `top_time` timestamp NULL DEFAULT 0000-00-00 00:00:00 ;");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'start_time')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `start_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'valid_thru')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `valid_thru` datetime NOT NULL DEFAULT '1970-01-01 00:00:00';");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'car')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `car` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'user_count')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `user_count` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'cost')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `cost` decimal(12,2) unsigned NOT NULL DEFAULT '0.00';");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'note')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `note` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'name')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `name` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'phone')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `phone` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'sex')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `sex` int(11) NOT NULL DEFAULT '1';");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'head')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `head` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'status')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `status` int(11) NOT NULL DEFAULT '0';");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'order_id')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `order_id` int(11) NOT NULL DEFAULT '0';");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'from_longitude')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `from_longitude` decimal(18,10) NOT NULL DEFAULT '0.0000000000';");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'from_latitude')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `from_latitude` decimal(18,10) NOT NULL DEFAULT '0.0000000000';");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'to_latitude')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `to_latitude` decimal(18,10) NOT NULL DEFAULT '0.0000000000';");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'to_longitude')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `to_longitude` decimal(18,10) NOT NULL DEFAULT '0.0000000000';");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'view_count')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `view_count` int(10) unsigned NOT NULL DEFAULT '0';");
	}	
}
if(pdo_tableexists('slj123_pc_index')) {
	if(!pdo_fieldexists('slj123_pc_index',  'verified')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_index')." ADD `verified` tinyint(1) unsigned NOT NULL DEFAULT '0';");
	}	
}
if(pdo_tableexists('slj123_pc_order')) {
	if(!pdo_fieldexists('slj123_pc_order',  'id')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_order')." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
	}	
}
if(pdo_tableexists('slj123_pc_order')) {
	if(!pdo_fieldexists('slj123_pc_order',  'weid')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_order')." ADD `weid` int(10) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_order')) {
	if(!pdo_fieldexists('slj123_pc_order',  'title')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_order')." ADD `title` varchar(255) DEFAULT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_order')) {
	if(!pdo_fieldexists('slj123_pc_order',  'money')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_order')." ADD `money` decimal(11,2) DEFAULT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_order')) {
	if(!pdo_fieldexists('slj123_pc_order',  'status')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_order')." ADD `status` int(11) DEFAULT NULL COMMENT '0 未支付 1已支付';");
	}	
}
if(pdo_tableexists('slj123_pc_order')) {
	if(!pdo_fieldexists('slj123_pc_order',  'user_id')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_order')." ADD `user_id` int(11) DEFAULT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_order')) {
	if(!pdo_fieldexists('slj123_pc_order',  'extra')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_order')." ADD `extra` varchar(255) DEFAULT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_order')) {
	if(!pdo_fieldexists('slj123_pc_order',  'create_time')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_order')." ADD `create_time` int(11) unsigned DEFAULT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_setting')) {
	if(!pdo_fieldexists('slj123_pc_setting',  'id')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_setting')." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
	}	
}
if(pdo_tableexists('slj123_pc_setting')) {
	if(!pdo_fieldexists('slj123_pc_setting',  'weid')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_setting')." ADD `weid` int(10) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_setting')) {
	if(!pdo_fieldexists('slj123_pc_setting',  'people_post_cost')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_setting')." ADD `people_post_cost` decimal(11,2) DEFAULT NULL DEFAULT '0.00' COMMENT '发布找人时金额';");
	}	
}
if(pdo_tableexists('slj123_pc_setting')) {
	if(!pdo_fieldexists('slj123_pc_setting',  'car_post_cost')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_setting')." ADD `car_post_cost` decimal(11,2) DEFAULT NULL DEFAULT '0.00' COMMENT '发布找车时金额';");
	}	
}
if(pdo_tableexists('slj123_pc_setting')) {
	if(!pdo_fieldexists('slj123_pc_setting',  'car_post_cost1')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_setting')." ADD `car_post_cost1` decimal(11,2) DEFAULT NULL DEFAULT '0.00';");
	}	
}
if(pdo_tableexists('slj123_pc_setting')) {
	if(!pdo_fieldexists('slj123_pc_setting',  'car_post_cost2')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_setting')." ADD `car_post_cost2` decimal(11,2) DEFAULT NULL DEFAULT '0.00';");
	}	
}
if(pdo_tableexists('slj123_pc_setting')) {
	if(!pdo_fieldexists('slj123_pc_setting',  'top_time_cost')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_setting')." ADD `top_time_cost` decimal(11,2) DEFAULT NULL DEFAULT '0.00' COMMENT '置顶每小时金额';");
	}	
}
if(pdo_tableexists('slj123_pc_setting')) {
	if(!pdo_fieldexists('slj123_pc_setting',  'banner')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_setting')." ADD `banner` varchar(255) DEFAULT NULL COMMENT '首页广告位';");
	}	
}
if(pdo_tableexists('slj123_pc_setting')) {
	if(!pdo_fieldexists('slj123_pc_setting',  'notice_content')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_setting')." ADD `notice_content` text DEFAULT NULL COMMENT '公告内容';");
	}	
}
if(pdo_tableexists('slj123_pc_setting')) {
	if(!pdo_fieldexists('slj123_pc_setting',  'notice_title')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_setting')." ADD `notice_title` varchar(255) DEFAULT NULL COMMENT '公告标题';");
	}	
}
if(pdo_tableexists('slj123_pc_setting')) {
	if(!pdo_fieldexists('slj123_pc_setting',  'share_pic')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_setting')." ADD `share_pic` varchar(255) DEFAULT NULL COMMENT '分享图片';");
	}	
}
if(pdo_tableexists('slj123_pc_setting')) {
	if(!pdo_fieldexists('slj123_pc_setting',  'share_title')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_setting')." ADD `share_title` varchar(255) DEFAULT NULL COMMENT '分享标题';");
	}	
}
if(pdo_tableexists('slj123_pc_setting')) {
	if(!pdo_fieldexists('slj123_pc_setting',  'share_des')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_setting')." ADD `share_des` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_setting')) {
	if(!pdo_fieldexists('slj123_pc_setting',  'banner_link')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_setting')." ADD `banner_link` text NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_setting')) {
	if(!pdo_fieldexists('slj123_pc_setting',  'notice')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_setting')." ADD `notice` text NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_setting')) {
	if(!pdo_fieldexists('slj123_pc_setting',  'isopen_renzheng')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_setting')." ADD `isopen_renzheng` int(10) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_setting')) {
	if(!pdo_fieldexists('slj123_pc_setting',  'unitid')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_setting')." ADD `unitid` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_sms_code')) {
	if(!pdo_fieldexists('slj123_pc_sms_code',  'openid')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_sms_code')." ADD `openid` varchar(50) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_sms_code')) {
	if(!pdo_fieldexists('slj123_pc_sms_code',  'code')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_sms_code')." ADD `code` varchar(10) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_sms_code')) {
	if(!pdo_fieldexists('slj123_pc_sms_code',  'timestamp')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_sms_code')." ADD `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'id')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `id` int(11) unsigned NOT NULL AUTO_INCREMENT;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'weid')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `weid` int(10) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'uid')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `uid` int(10) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'wx_open_id')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `wx_open_id` varchar(255) DEFAULT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'wx_id')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `wx_id` varchar(64) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'nickname')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `nickname` varchar(64) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'name')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `name` varchar(255) DEFAULT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'tel')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `tel` varchar(20) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'sex')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `sex` varchar(255) DEFAULT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'address')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `address` varchar(10) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'head')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `head` varchar(255) DEFAULT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'mag_open_id')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `mag_open_id` varchar(255) DEFAULT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'phone')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `phone` varchar(255) DEFAULT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'gender')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `gender` tinyint(1) unsigned NOT NULL DEFAULT '0';");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'identity')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `identity` varchar(20) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'realname')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `realname` varchar(10) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'area')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `area` varchar(30) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'initial_driving_license_date')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `initial_driving_license_date` date NOT NULL DEFAULT '1970-01-01';");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'car_number')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `car_number` varchar(10) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'car_model')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `car_model` varchar(10) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'car_color')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `car_color` varchar(10) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'car_owner')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `car_owner` varchar(10) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'car_register_date')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `car_register_date` date NOT NULL DEFAULT '1970-01-01';");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'driving_license')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `driving_license` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'driving_permit')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `driving_permit` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'identity_front')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `identity_front` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'identity_back')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `identity_back` varchar(255) NOT NULL;");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'verified')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `verified` tinyint(1) unsigned NOT NULL DEFAULT '0';");
	}	
}
if(pdo_tableexists('slj123_pc_user')) {
	if(!pdo_fieldexists('slj123_pc_user',  'update_time')) {
		pdo_query("ALTER TABLE ".tablename('slj123_pc_user')." ADD `update_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00';");
	}	
}
